﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Entities;
using System.Data;
using System.Data.SqlClient;


namespace DataAccess
{
    public class WithDrawLimitDA
    {
        ConnectDB cn = new ConnectDB();
        public bool BlockCard(string card)
        {
            bool kt = false;
            SqlConnection con = new SqlConnection(cn.ConnectionString());
            con.Open();
            SqlCommand cmd = new SqlCommand("ProCardUpdateByCarNo", con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(new SqlParameter("@CardNo", card));
            cmd.ExecuteNonQuery();
            cmd.Dispose();
            return kt;
        }
    }
}
